<? include"../koneksi/koneksi.php"; ?>
<? include ("../lib/inc_kdauto.php");?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<script type="text/javascript" src="styless/ewp.js"></script>
<script type="text/javascript" src="styless/ewp1.js"></script>
<script type="text/javascript" src="calendarDateInput.js"></script>


<style type="text/css"></style>
<link href="../lib/styles.css" rel="stylesheet" type="text/css">
<link href="../lib/tbl_css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style28 {color: #FFFFFF; }
-->
</style>
<script type="text/JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}

function MM_validateForm() { //v4.0
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
    if (val) { nm=val.name; if ((val=val.value)!="") {
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
      } else if (test!='R') { num = parseFloat(val);
        if (isNaN(val)) errors+='- '+nm+' harus berisi angka.\n';
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
          min=test.substring(8,p); max=test.substring(p+1);
          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
    } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' harus diperbaiki.\n'; }
  } if (errors) alert('Maaf data tidak boleh kosong :\n'+errors);
  document.MM_returnValue = (errors == '');
}
//-->
</script>
</head>

<body onload="MM_preloadImages('../gambar/tambah01.gif')">
<TABLE class="hidden" width=100% border=0 align="center" cellPadding=0 cellSpacing=0>
        <TBODY>
        <TR vAlign=top>
          <TD style="BACKGROUND: url(../gambar/gri_sus.gif) repeat-x" height=50 
          width=100% colSpan=2><table width="100%" height="15" border="0">
            <tr>
              <td height="35" background="../gambar/index_07.jpg"><H6 class=title title="Detail Karyawan">Jobdesc Kualifkasi</H6></td>
            </tr>
          </table></TD>
        </TR>
        <TR>
          <TD width=788 colSpan=3>
            <TABLE border=0 cellSpacing=0 cellPadding=0 width=100%>
              <TBODY>
              <TR>
                <TD><IMG border=0 alt=space 
                  src="../gambar/spacer.gif" 
                  width=1 height=1></TD></TR>
              <TR>
                <TD 
                style="BACKGROUND: url(../images/shadow_sub_verde.gif) #f4f4f4 repeat-x" 
                width=788 colSpan=2>
                  <TABLE border=0 cellSpacing=0 cellPadding=0 width=788>
                    <TBODY>
                    <TR>
                      <TD width="36" rowspan="2" valign="top">&nbsp;&nbsp;<img src="../gambar/001_21.png" width="24" height="24"><IMG alt=space 
                        src="../gambar/spacer.gif" 
                        width=1 height=10></TD>
                      <TD width="752" valign="top"><a href="?act=jobdesc"><span class="linkuri_bottom2">Kembali</span></a></TD>
                    </TR>
                    <TR>
                      <TD>&nbsp;</TD>
                    </TR></TBODY></TABLE></TD></TR>
              <TR>
            <TD><IMG border=0 alt=space 
                  src="../gambar/spacer.gif" 
                  width=1 height=5></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td><a href="index.php?act=in_matkul"></a></h2></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td><form action="exe_in_master.php" method="post" name="form1" onsubmit="MM_validateForm('nodet_jobdesc','','R','nama_kualifikasi','','R','kode_jobdesc','','R','materi','','R');return document.MM_returnValue">
	  <table width="80%" border="0" align="center" cellpadding="2" cellspacing="1">
  <tr>
    <td>No. Detail Jobdesc </td>
    <td>:</td>
    <td><input name="nodet_jobdesc" type="text" id="nodet_jobdesc" tabindex="1" maxlength="5" value="<? echo kd_auto("jobdesc_kualifikasi","K-"); ?>"disabled="disabled"> 		
  <input name="nodet_jobdesc" type="hidden" id="nodet_jobdesc" tabindex="1" maxlength="5" value="<? echo kd_auto("jobdesc_kualifikasi","K-"); ?>" />	</td>
  </tr>
  <tr>
    <td>Nama Kualifikasi </td>
    <td>:</td>
    <td><input type="text" name="nama_kualifikasi" maxlength="35" size="35" /></td>
  </tr>
  <tr>
    <td width="25%">Kode Jobdesc </td>
    <td width="2%">:</td>
    <td width="73%"><div align="left">
      <input name="kode_jobdesc" type="text" id="kode_jobdesc" tabindex="1" maxlength="5" value="<? echo"$kd_jobdesc"; ?>"disabled="disabled" />
      <input name="kode_jobdesc" type="hidden" id="kode_jobdesc" tabindex="1" maxlength="5" value="<? echo"$kd_jobdesc"; ?>" />
    </div></td>
  </tr>
  <tr>
    <td><div align="left">Materi</div></td>
    <td>:</td>
    <td><div align="left">
      <select name="materi">
        <option value="">-----Pilih------</option>
        <?php
include "../koneksi/koneksi.php";
$perintah2 ="SELECT * FROM materi m WHERE m.kd_materi not in(select jk.kd_materi from jobdesc_kualifikasi jk where jk.kd_jobdesc='$kd_jobdesc')";
$permintaan2=mysql_query($perintah2)or die ("nggak dapat dibuka");
while($hasil=mysql_fetch_row($permintaan2))
{
echo "<option value=$hasil[0]>$hasil[1]</option>";
}
?>
      </select>
    </div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><input type="submit" name="tambah_job_kualifikasi" value="Tambah" />
      <input type="reset" value="Kosong" name="kosong" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><div align="left"><font color="#0000FF"><? echo"$sukses"; ?></font></div></td>
  </tr>
</table>
<center>
</center>
</form></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
    </table> 
	

<table width="99%" border="1" align="center" style="border-collapse: collapse;" bordercolor="#cccccc">
  <tr bgcolor="#660066" class="FOOTWARNA">
    <td width="6%" id="tdUp"><div align="center" class="style28">No</div></td>
    <td width="16%" id="tdUp"><div align="center" class="style28">Kelompok</div></td>
    <td width="21%" id="tdUp"><span class="style28">Kualifikasi</span></td>
    <td width="14%" id="tdUp"><div align="center" class="style28">Materi</div></td>
    <td width="15%" id="tdUp"><div align="center" class="style28">Bagian</div></td>
    <td width="14%" id="tdUp"><div align="center" class="style28">Seksi</div></td>
    <td width="14%" id="tdUp"><div align="center" class="style28">Keterangan</div></td>
  </tr>
  <tr>
<? include"../koneksi/koneksi.php";
 $limit=15;
 if(empty($halaman)){
 $offset=0;
 $halaman=1;}
 else{
 $offset=($halaman-1) * $limit; }
 
$lihat=mysql_query("select * from jobdesc j, materi m, jobdesc_kualifikasi jk, kelompok k, bagian b, seksi s
					where jk.kd_materi=m.kd_materi and jk.kd_jobdesc=j.kd_jobdesc and
					b.kd_bagian=s.kd_bagian and k.kd_kelompok=j.kd_kelompok and k.kd_seksi=s.kd_seksi and jk.kd_jobdesc='$kd_jobdesc'
					limit $offset,$limit");
 while($hs=mysql_fetch_array($lihat))
 {
 	if($j==0){
	echo"<tr id='tampil'>";
	$j++;}
	else{
	echo"<tr id='tampil2'>";
	$j--;}
	$no++;
?> 



    <td><div align="center"><? echo"$no"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_kelompok]"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_kualifikasi]"; ?></div></td>
    <td><div align="center"><? echo"$hs[nm_materi]"; ?></td>
    <td><div align="center"><? echo"$hs[nm_bagian]"; ?></div></td>
    <td>
	  <div align="center"><? echo"$hs[nm_seksi]"; ?></div></td>
    <td id="tdBott"><div align="center"><a href="index.php?act=ed_training&no_training=<? echo"$hs[no_training]"; ?>">Edit</a> | <a href="exe_hap_master.php?act=hapus_training&no_training=<?=$hs[no_training]; ?>" target="_self" 
	 onClick="return confirm('Apakah Anda yakin menghapus data ini ?' +  '\n' 
							+ ' <?php echo "- instruktur= $hs[nm_instruktur]"; ?> ' +  '\n \n' 
							+ ' Jika YA silahkan klik OK, Jika TIDAK klik CANCEL.')">Hapus </a> </div></td>
  </tr>
  <? } ?>
</table>

<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="style12">
  <tr>
    <td><?
$lihat2=mysql_query("select * from jobdesc j, materi m, jobdesc_kualifikasi jk, kelompok k, bagian b, seksi s
					where jk.kd_materi=m.kd_materi and jk.kd_jobdesc=j.kd_jobdesc and
					b.kd_bagian=s.kd_bagian and k.kd_kelompok=j.kd_kelompok and k.kd_seksi=s.kd_seksi and jk.kd_jobdesc='$kd_jobdesc'");
$jumbaris=mysql_num_rows($lihat2);
$total_halaman=ceil($jumbaris/$limit);

if(!empty($halaman) && $halaman!=1)
	{
	$previous=$halaman-1;
	echo"<a href=?act=training&halaman=$previous>Previous</a> -";
	}
	else{
	echo"Previous -";
	}

for($i=1;$i<=$total_halaman;$i++)
if($i!=$halaman)
	{
	echo"<a href=?act=training&halaman=$i>$i</a> -";
	}
	else{
	echo"$i -"; }

if($halaman<$total_halaman)
	{
	$next=$halaman+1;
	echo"<a href=?act=training&halaman=$next>Next</a>";
	echo"<center>Jumlah Data : $jumbaris</center>"; }
	else{
	echo"Next";
	echo"<center>Jumlah Data : $jumbaris</center>"; }
?>
    </td>
  </tr>
</table>
	
	</td>
  </tr>
  <tr>
    <td><p>&nbsp;</p></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>
